Excel如何算工龄 第一个起始日期第二个结束日期算出年月?答:在C2中输入或复制粘贴下列公式 =DATEDIF(A2,B2,"Y")&"年"&DATEDIF(A2,B2,"YM")&"月"或=IF(DATEDIF(A2,B2,"Y")>0,DATEDIF(A2,B2,"Y")&"年","")&IF(DATEDIF(A2,B2,"YM")>0,DATEDIF(A2,B2,"YM")&"月","")下拉填充
excel表里知道入职时间,求工龄工资答:以附图举例,在D2输入以下公式 =IF(A2="总监",IF(AND(C2>=0.5,C2<1),300,IF(C2>=1,MIN(500+INT((C2-1)/0.5)*300,1000))),IF(OR(A2={"经理","主管"}),IF(AND(C2>=0.5,C2<1),200,IF(C2>=1,MIN(400+INT((C2-1)/0.5)*200,1000))),IF(A2="专员",IF(AND(C2...
用Excel计算年假,假设在司工龄小于1年则不能享有年假,工龄小于3年者答:公式如下:=IF(DATEDIF(B7,TODAY(),"y")<1,"无年假",IF(DATEDIF(B7,TODAY(),"y")<3,"10天",DATEDIF(B7,TODAY(),"y")+7&"天"))